SQL для тестировщика

Дана следующая таблица:

| OrderID | CustomerID |  OrderDate | TotalAmount |
|---------|------------|------------|-------------|
|    1    |    101     | 2022-05-15 |    500      |
|    2    |    102     | 2022-06-20 |    750      |
|    3    |    103     | 2022-06-25 |   1000      |
|    4    |    101     | 2022-07-10 |    300      |
|    5    |    104     | 2022-08-05 |    900      |

Какой из следующих SQL запросов вернет CustomerID и максимальный TotalAmount среди всех заказов?

A)

SELECT CustomerID, MAX(TotalAmount) FROM Orders

SELECT CustomerID, TotalAmount FROM Orders WHERE TotalAmount = MAX(TotalAmount)

SELECT CustomerID, TotalAmount FROM Orders WHERE TotalAmount = (SELECT MAX(TotalAmount) FROM Orders)

D) SELECT CustomerID, MAX(TotalAmount) FROM Orders GROUP BY CustomerID

www.tg-me.com/ca/SQL для тестировщика/com.sql_for_qa/108

2.2K viewsJun 15, 2023 at 13:56

tg-me.com/sql_for_qa/108

Create: 2023-06-15
Last Update: 2025-07-01 21:53:16

Дана следующая таблица:

| OrderID | CustomerID | OrderDate | TotalAmount | |---------|------------|------------|-------------| | 1 | 101 | 2022-05-15 | 500 | | 2 | 102 | 2022-06-20 | 750 | | 3 | 103 | 2022-06-25 | 1000 | | 4 | 101 | 2022-07-10 | 300 | | 5 | 104 | 2022-08-05 | 900 |Какой из следующих SQL запросов вернет CustomerID и максимальный TotalAmount среди всех заказов?

A) SELECT CustomerID, MAX(TotalAmount) FROM OrdersB) SELECT CustomerID, TotalAmount FROM Orders WHERE TotalAmount = MAX(TotalAmount)C) SELECT CustomerID, TotalAmount FROM Orders WHERE TotalAmount = (SELECT MAX(TotalAmount) FROM Orders)D) SELECT CustomerID, MAX(TotalAmount) FROM Orders GROUP BY CustomerID

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/108

SQL для тестировщика Telegram | DID YOU KNOW?

Telegram hopes to raise $1bn with a convertible bond private placement

The super secure UAE-based Telegram messenger service, developed by Russian-born software icon Pavel Durov, is looking to raise $1bn through a bond placement to a limited number of investors from Russia, Europe, Asia and the Middle East, the Kommersant daily reported citing unnamed sources on February 18, 2021.The issue reportedly comprises exchange bonds that could be converted into equity in the messaging service that is currently 100% owned by Durov and his brother Nikolai.Kommersant reports that the price of the conversion would be at a 10% discount to a potential IPO should it happen within five years.The minimum bond placement is said to be set at $50mn, but could be lowered to $10mn. Five-year bonds could carry an annual coupon of 7-8%.

Launched in 2013, Telegram allows users to broadcast messages to a following via “channels”, or create public and private groups that are simple for others to access. Users can also send and receive large data files, including text and zip files, directly via the app.The platform said it has more than 500m active users, and topped 1bn downloads in August, according to data from SensorTower.SQL для тестировщика from ca